<?php namespace AlexBurcow\Fayna\Updates;

use Schema;
use October\Rain\Database\Updates\Migration;

class BuilderTableUpdateAlexburcowFaynaRubu extends Migration
{
    public function up()
    {
        Schema::table('alexburcow_fayna_rubu', function($table)
        {
            $table->text('nazvanie');
            $table->text('pervishnoeopisnie');
            $table->text('zena');
            $table->text('kartinka1');
            $table->text('kartinka2');
            $table->text('kartinka3');
            $table->text('kartinka4');
            $table->text('kartinka5');
            $table->text('kartinka6');
            $table->text('kartinka7');
            $table->text('dlinatela');
            $table->text('kategorii');
            $table->text('minocobei');
            $table->text('minackvarium');
            $table->text('temp');
            $table->text('chestkosti');
            $table->text('kislotnosti');
            $table->text('opisanie');
            $table->text('vnalichii')->nullable(false)->unsigned(false)->default(null)->comment(null)->change();
            $table->primary(['id']);
        });
    }
    
    public function down()
    {
        Schema::table('alexburcow_fayna_rubu', function($table)
        {
            $table->dropPrimary(['id']);
            $table->dropColumn('nazvanie');
            $table->dropColumn('pervishnoeopisnie');
            $table->dropColumn('zena');
            $table->dropColumn('kartinka1');
            $table->dropColumn('kartinka2');
            $table->dropColumn('kartinka3');
            $table->dropColumn('kartinka4');
            $table->dropColumn('kartinka5');
            $table->dropColumn('kartinka6');
            $table->dropColumn('kartinka7');
            $table->dropColumn('dlinatela');
            $table->dropColumn('kategorii');
            $table->dropColumn('minocobei');
            $table->dropColumn('minackvarium');
            $table->dropColumn('temp');
            $table->dropColumn('chestkosti');
            $table->dropColumn('kislotnosti');
            $table->dropColumn('opisanie');
            $table->time('vnalichii')->nullable(false)->unsigned(false)->default(null)->comment(null)->change();
        });
    }
}
